IF OBJECT_ID('ssf.dpnd_get_object_summary') IS NOT NULL
	DROP FUNCTION ssf.dpnd_get_object_summary
GO

CREATE FUNCTION ssf.dpnd_get_object_summary (
	@dpnd_object_name NVARCHAR(256)
)
RETURNS TABLE
AS
	RETURN (
		SELECT header_object_id
			, dpnd_object_name
			, object_type
			, purpose
			, return_data_type
			, create_date
			, create_user
		FROM ssf.dpnd_header_object WITH (NOLOCK)
		WHERE dpnd_object_name = @dpnd_object_name
	)
GO
